Is there a maximum number of character $_POST will/can return from a
text field. I have an online form that was driving me nuts trying to
troubleshoot, as most orders were coming in fine, but this one would
not. I narrowed down to the length of the "customer description" field
which has no limits on the form or in the database. I was told there
was a limit to how much $_POST could return. Can someone advise?
Unless you are using a text field (which holds 64K [mysql]) a normal varcha=
r maxs out at 255 characters
=20
Post is limited by the php.ini file amounts (usually in the megabyte range)=
..
=20
what is the size of the post?
=20
Bastien> Date: Fri, 12 Oct 2007 10:41:15 -0400> From: pvanbuskirk@otc.fsu.e=
du> To: php-db@lists.php.net> Subject: [PHP-DB] php maximum characters in t=
ext field> > Is there a maximum number of character $_POST will/can return =
from a> text field. I have an online form that was driving me nuts trying t=
o> troubleshoot, as most orders were coming in fine, but this one would> no=
t. I narrowed down to the length of the "customer description" field> which=
has no limits on the form or in the database. I was told there> was a limi=
t to how much $_POST could return. Can someone advise?> > > > Thanks!> > Tr=
ish>=20
____________________________________________________________ _____
Express yourself with free Messenger emoticons. Get them today!
http://www.freemessengeremoticons.ca/?icid=3DEMENCA122=
The info he was trying to submit was 883 characters, including spaces
(counted in Word). Many times, people have very detailed descriptions
they need to send in. Can you think of a way to work around this
limitation? Also, what happened when he tried to submit is he got an
email back with "Undefined variable" errors wherever the database was
supposed to send back info, and no record was created.
=20
From: Bastien Koert [mailto:bastien_k@hotmail.com]=20
Sent: Friday, October 12, 2007 11:12 AM
To: VanBuskirk, Patricia; php-db@lists.php.net
Subject: RE: [PHP-DB] php maximum characters in text field
=20
Unless you are using a text field (which holds 64K [mysql]) a normal
varchar maxs out at 255 characters
=20
Post is limited by the php.ini file amounts (usually in the megabyte
range).
=20
what is the size of the post?
=20
Bastien
> Date: Fri, 12 Oct 2007 10:41:15 -0400
> From: pvanbuskirk@otc.fsu.edu
> To: php-db@lists.php.net
> Subject: [PHP-DB] php maximum characters in text field
>=20
> Is there a maximum number of character $_POST will/can return from a
> text field. I have an online form that was driving me nuts trying to
> troubleshoot, as most orders were coming in fine, but this one would
> not. I narrowed down to the length of the "customer description" field
> which has no limits on the form or in the database. I was told there
> was a limit to how much $_POST could return. Can someone advise?
>=20
>=20
>=20
> Thanks!
>=20
> Trish
>=20
________________________________
Express yourself with free Messenger emoticons. Get them today! =20
And how is the table / field of interest configured? 833 will obviously not=
fit into a 255 varchar field...
=20
Bastien
Subject: RE: [PHP-DB] php maximum characters in text fieldDate: Fri, 12 Oct=
2007 11:24:14 -0400From: pvanbuskirk@otc.fsu.eduTo: bastien_k@hotmail.com;=
php-db@lists.php.net
The info he was trying to submit was 883 characters, including spaces (coun=
ted in Word). Many times, people have very detailed descriptions they need=
to send in. Can you think of a way to work around this limitation? Also,=
what happened when he tried to submit is he got an email back with =93Unde=
fined variable=94 errors wherever the database was supposed to send back in=
fo, and no record was created.
=20
From: Bastien Koert [mailto:bastien_k@hotmail.com] Sent: Friday, October 12=
, 2007 11:12 AMTo: VanBuskirk, Patricia; php-db@lists.php.netSubject: RE: [=
PHP-DB] php maximum characters in text field
=20
Unless you are using a text field (which holds 64K [mysql]) a normal varcha=
r maxs out at 255 characters Post is limited by the php.ini file amounts (u=
sually in the megabyte range). what is the size of the post? Bastien> Date:=
Fri, 12 Oct 2007 10:41:15 -0400> From: pvanbuskirk@otc.fsu.edu> To: php-db=
@lists.php.net> Subject: [PHP-DB] php maximum characters in text field> > I=
s there a maximum number of character $_POST will/can return from a> text f=
ield. I have an online form that was driving me nuts trying to> troubleshoo=
t, as most orders were coming in fine, but this one would> not. I narrowed =
down to the length of the "customer description" field> which has no limits=
on the form or in the database. I was told there> was a limit to how much =
$_POST could return. Can someone advise?> > > > Thanks!> > Trish>=20
Express yourself with free Messenger emoticons. Get them today!
____________________________________________________________ _____
R U Ready for Windows Live Messenger Beta 8.5? Try it today!
http://entertainment.sympatico.msn.ca/WindowsLiveMessenger=
The field on the form is as such:
name=3D"Customer_Description"
cols=3D100 rows=3D10 tabindex=3D"44">
The confirmation page is:
?>
=20
From: Bastien Koert [mailto:bastien_k@hotmail.com]=20
Sent: Friday, October 12, 2007 11:26 AM
To: VanBuskirk, Patricia; php-db@lists.php.net
Subject: RE: [PHP-DB] php maximum characters in text field
=20
And how is the table / field of interest configured? 833 will obviously
not fit into a 255 varchar field...
=20
Bastien
________________________________
Subject: RE: [PHP-DB] php maximum characters in text field
Date: Fri, 12 Oct 2007 11:24:14 -0400
From: pvanbuskirk@otc.fsu.edu
To: bastien_k@hotmail.com; php-db@lists.php.net
The info he was trying to submit was 883 characters, including spaces
(counted in Word). Many times, people have very detailed descriptions
they need to send in. Can you think of a way to work around this
limitation? Also, what happened when he tried to submit is he got an
email back with "Undefined variable" errors wherever the database was
supposed to send back info, and no record was created.
=20
From: Bastien Koert [mailto:bastien_k@hotmail.com]=20
Sent: Friday, October 12, 2007 11:12 AM
To: VanBuskirk, Patricia; php-db@lists.php.net
Subject: RE: [PHP-DB] php maximum characters in text field
=20
Unless you are using a text field (which holds 64K [mysql]) a normal
varchar maxs out at 255 characters
=20
Post is limited by the php.ini file amounts (usually in the megabyte
range).
=20
what is the size of the post?
=20
Bastien
> Date: Fri, 12 Oct 2007 10:41:15 -0400
> From: pvanbuskirk@otc.fsu.edu
> To: php-db@lists.php.net
> Subject: [PHP-DB] php maximum characters in text field
>=20
> Is there a maximum number of character $_POST will/can return from a
> text field. I have an online form that was driving me nuts trying to
> troubleshoot, as most orders were coming in fine, but this one would
> not. I narrowed down to the length of the "customer description" field
> which has no limits on the form or in the database. I was told there
> was a limit to how much $_POST could return. Can someone advise?
>=20
>=20
>=20
> Thanks!
>=20
> Trish
>=20
________________________________
Express yourself with free Messenger emoticons. Get them today! =20
=20
________________________________
R U Ready for Windows Live Messenger Beta 8.5? Try it today! =20
Yes, that is the HTML and the PHP code to check. What about the php code t=
o go to the db?
=20
Bastien> Date: Fri, 12 Oct 2007 11:42:25 -0400> From: pvanbuskirk@otc.fsu.e=
du> To: bastien_k@hotmail.com; php-db@lists.php.net> Subject: RE: [PHP-DB] =
php maximum characters in text field> > The field on the form is as such: <=
TEXTAREA name=3D"Customer_Description"> cols=3D100 rows=3D10 tabindex=3D"44=
">> > The confirmation page is:
cription']);> ?>> > > > From: Bastien Koert [mailto:bastien_k@hotmail.com] =
> Sent: Friday, October 12, 2007 11:26 AM> To: VanBuskirk, Patricia; php-db=
@lists.php.net> Subject: RE: [PHP-DB] php maximum characters in text field>=
> > > And how is the table / field of interest configured? 833 will obviou=
sly> not fit into a 255 varchar field...> > Bastien> > > > ________________=
________________> > Subject: RE: [PHP-DB] php maximum characters in text fi=
eld> Date: Fri, 12 Oct 2007 11:24:14 -0400> From: pvanbuskirk@otc.fsu.edu> =
To: bastien_k@hotmail.com; php-db@lists.php.net> > The info he was trying t=
o submit was 883 characters, including spaces> (counted in Word). Many time=
s, people have very detailed descriptions> they need to send in. Can you th=
ink of a way to work around this> limitation? Also, what happened when he t=
ried to submit is he got an> email back with "Undefined variable" errors wh=
erever the database was> supposed to send back info, and no record was crea=
ted.> > > > From: Bastien Koert [mailto:bastien_k@hotmail.com] > Sent: Frid=
ay, October 12, 2007 11:12 AM> To: VanBuskirk, Patricia; php-db@lists.php.n=
et> Subject: RE: [PHP-DB] php maximum characters in text field> > > > Unles=
s you are using a text field (which holds 64K [mysql]) a normal> varchar ma=
xs out at 255 characters> > Post is limited by the php.ini file amounts (us=
ually in the megabyte> range).> > what is the size of the post?> > Bastien>=
> > Date: Fri, 12 Oct 2007 10:41:15 -0400> > From: pvanbuskirk@otc.fsu.edu=
> > To: php-db@lists.php.net> > Subject: [PHP-DB] php maximum characters in=
text field> > > > Is there a maximum number of character $_POST will/can r=
eturn from a> > text field. I have an online form that was driving me nuts =
trying to> > troubleshoot, as most orders were coming in fine, but this one=
would> > not. I narrowed down to the length of the "customer description" =
field> > which has no limits on the form or in the database. I was told the=
re> > was a limit to how much $_POST could return. Can someone advise?> > >=
> > > > > Thanks!> > > > Trish> > > > ________________________________> > =
Express yourself with free Messenger emoticons. Get them today!>
w.freemessengeremoticons.ca/?icid=3DEMENCA122> > > > > ____________________=
____________> > R U Ready for Windows Live Messenger Beta 8.5? Try it today=
!> >=20
____________________________________________________________ _____
Send a smile, make someone laugh, have some fun! Start now!
http://www.freemessengeremoticons.ca/?icid=3DEMENCA122=
--_1f8142a7-1bd0-4371-b727-3f1c07d301d3_--
RE: php maximum characters in text field
am 13.10.2007 18:54:37 von Juergen Wind
>varchar maxs out at 255 characters
just for clarification, mysql varchar easily can hold more than 255
characters
(I remember it was the case in ancient 3.x times)
only if one wants to store newlines he must use type "text"
just my 2 cent
--
View this message in context: http://www.nabble.com/php-maximum-characters-in-text-field-t f4614039.html#a13191426
Sent from the Php - Database mailing list archive at Nabble.com.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: php maximum characters in text field
am 15.10.2007 12:04:58 von Oskar
VanBuskirk, Patricia napsal(a):
> The info he was trying to submit was 883 characters, including spaces
> (counted in Word). Many times, people have very detailed descriptions
> they need to send in. Can you think of a way to work around this
> limitation? Also, what happened when he tried to submit is he got an
> email back with "Undefined variable" errors wherever the database was
> supposed to send back info, and no record was created.
>
>
I guess you are using get method of http request which is limited by
"maximum URL Length" (2083 chars in IE). Force the browser to use post
by
> >varchar maxs out at 255 characters
> just for clarification, mysql varchar easily can hold more than 255
> characters=20
> (I remember it was the case in ancient 3.x times)=20
> only if one wants to store newlines he must use type "text"
>=20
> just my 2 cent
News to me, so I check the docs.
http://dev.mysql.com/doc/refman/5.0/en/char.html
Apparently varchar can "easily" hold more than 255 chars IF YOU USE VERSION=
5.0.3 OR LATER.
"Values in VARCHAR columns are variable-length
strings. The length can be specified as a value from 0 to 255
before MySQL 5.0.3, and 0 to 65,535 in 5.0.3 and later versions."
We assume the OP is using
RE: php maximum characters in text field
am 15.10.2007 18:48:16 von pvanbuskirk
I am starting to believe it is NOT the character length that is causing =
the problem. We have received other orders with more in it than that, =
and they came in ok. I think there may be something in the input that =
php does not like. I've been searching for code that will "clean up" =
input, possibly preg_replace?
-----Original Message-----
From: Instruct ICC [mailto:instructicc@hotmail.com]=20
Sent: Monday, October 15, 2007 10:37 AM
To: php-db@lists.php.net
Subject: RE: [PHP-DB] php maximum characters in text field
> >varchar maxs out at 255 characters
> just for clarification, mysql varchar easily can hold more than 255
> characters=20
> (I remember it was the case in ancient 3.x times)=20
> only if one wants to store newlines he must use type "text"
>=20
> just my 2 cent
News to me, so I check the docs.
http://dev.mysql.com/doc/refman/5.0/en/char.html
Apparently varchar can "easily" hold more than 255 chars IF YOU USE =
VERSION 5.0.3 OR LATER.
"Values in VARCHAR columns are variable-length
strings. The length can be specified as a value from 0 to 255
before MySQL 5.0.3, and 0 to 65,535 in 5.0.3 and later =
versions."
We assume the OP is using
RE: php maximum characters in text field
am 15.10.2007 19:05:27 von Instruct ICC
> I am starting to believe it is NOT the character length that is causing t=
he problem. We have received other orders with more in it than that, and th=
ey came in ok. I think there may be something in the input that php does no=
t like. I've been searching for code that will "clean up" input, possibly p=
reg_replace?
Was the order received, but the text was shorter than expected?
Or was the order not "received" at all?
Check your mysql query log. It may show failed queries where bad character=
s made the query fail, perhaps using ' or "?
Use mysql_real_escape_string.
____________________________________________________________ _____
Climb to the top of the charts!=A0 Play Star Shuffle:=A0 the word scramble =
challenge with star power.
http://club.live.com/star_shuffle.aspx?icid=3Dstarshuffle_wl mailtextlink_oc=
t=
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: php maximum characters in text field
am 15.10.2007 19:29:02 von pvanbuskirk
It isn't sending to MySql, we use FileMaker Pro 9. A new record did not =
get made in the d'base... the confirmation email went out, but wherever =
info was supposed to kick back from the d'base (ie. Order number), it =
showed an "undefined variable" error.
-----Original Message-----
From: Instruct ICC [mailto:instructicc@hotmail.com]=20
Sent: Monday, October 15, 2007 1:05 PM
To: php-db@lists.php.net
Subject: RE: [PHP-DB] php maximum characters in text field
> I am starting to believe it is NOT the character length that is =
causing the problem. We have received other orders with more in it than =
that, and they came in ok. I think there may be something in the input =
that php does not like. I've been searching for code that will "clean =
up" input, possibly preg_replace?
Was the order received, but the text was shorter than expected?
Or was the order not "received" at all?
Check your mysql query log. It may show failed queries where bad =
characters made the query fail, perhaps using ' or "?
Use mysql_real_escape_string.
____________________________________________________________ _____
Climb to the top of the charts!=A0 Play Star Shuffle:=A0 the word =
scramble challenge with star power.
http://club.live.com/star_shuffle.aspx?icid=3Dstarshuffle_wl mailtextlink_=
oct
--=20
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Could it be an '&' ampersand in the data?
=20
Bastien> Date: Mon, 15 Oct 2007 13:29:02 -0400> From: pvanbuskirk@otc.fsu.e=
du> To: instructicc@hotmail.com; php-db@lists.php.net> Subject: RE: [PHP-DB=
] php maximum characters in text field> > It isn't sending to MySql, we use=
FileMaker Pro 9. A new record did not get made in the d'base... the confir=
mation email went out, but wherever info was supposed to kick back from the=
d'base (ie. Order number), it showed an "undefined variable" error.> > ---=
--Original Message-----> From: Instruct ICC [mailto:instructicc@hotmail.com=
] > Sent: Monday, October 15, 2007 1:05 PM> To: php-db@lists.php.net> Subje=
ct: RE: [PHP-DB] php maximum characters in text field> > > > I am starting =
to believe it is NOT the character length that is causing the problem. We h=
ave received other orders with more in it than that, and they came in ok. I=
think there may be something in the input that php does not like. I've bee=
n searching for code that will "clean up" input, possibly preg_replace?> > =
Was the order received, but the text was shorter than expected?> Or was the=
order not "received" at all?> > Check your mysql query log. It may show fa=
iled queries where bad characters made the query fail, perhaps using ' or "=
?> Use mysql_real_escape_string.> _________________________________________=
________________________> Climb to the top of the charts! Play Star Shuffl=
e: the word scramble challenge with star power.> http://club.live.com/star=
_shuffle.aspx?icid=3Dstarshuffle_wlmailtextlink_oct> -- > PHP Database Mail=
ing List (http://www.php.net/)> To unsubscribe, visit: http://www.php.net/u=
nsub.php> > -- > PHP Database Mailing List (http://www.php.net/)> To unsubs=
cribe, visit: http://www.php.net/unsub.php>=20
____________________________________________________________ _____
Express yourself with free Messenger emoticons. Get them today!
http://www.freemessengeremoticons.ca/?icid=3DEMENCA122=
--_f3c49e06-7f6c-449c-a9f9-5356a877c818_--
Re: php maximum characters in text field
am 15.10.2007 20:06:10 von Oskar
VanBuskirk, Patricia napsal(a):
> It isn't sending to MySql, we use FileMaker Pro 9. A new record did not get made in the d'base... the confirmation email went out, but wherever info was supposed to kick back from the d'base (ie. Order number), it showed an "undefined variable" error.
>
> -----Original Message-----
> From: Instruct ICC [mailto:instructicc@hotmail.com]
> Sent: Monday, October 15, 2007 1:05 PM
> To: php-db@lists.php.net
> Subject: RE: [PHP-DB] php maximum characters in text field
>
>
>
>> I am starting to believe it is NOT the character length that is causing the problem. We have received other orders with more in it than that, and they came in ok. I think there may be something in the input that php does not like. I've been searching for code that will "clean up" input, possibly preg_replace?
>>
>
> Was the order received, but the text was shorter than expected?
> Or was the order not "received" at all?
>
> Check your mysql query log. It may show failed queries where bad characters made the query fail, perhaps using ' or "?
> Use mysql_real_escape_string.
> ____________________________________________________________ _____
> Climb to the top of the charts! Play Star Shuffle: the word scramble challenge with star power.
> http://club.live.com/star_shuffle.aspx?icid=starshuffle_wlma iltextlink_oct
>
post the code (form + script that proccesses passed variables +
print_r($_POST) ), it'll make the things much quicker.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: php maximum characters in text field
am 15.10.2007 20:41:32 von pvanbuskirk
FORM PAGE:
The FSU Office of Telecommunications || Departmental<br />
Order Form
Helvetica,
sans-serif">If you DO NOT have=20
an FSU OMNI NUMBER & need to receive an invoice, click
href=3D"http://www2.otc.fsu.edu/Forms/TSR/OA_Order_Form.php" >HERE
face=3D"Verdana,
Arial, Helvetica, sans-serif">If you rely on the AUTOFILL/SAVED INFO
("cookies") feature on this form, please note that you will
need to reselect from the dropdown fields each time.
size=3D"1" face=3D"Verdana, Arial, Helvetica, sans-serif">
color=3D"#CC0000">HINT: By =
typing
the first few letters of a drop-down list, the selection will
"jump" to that area of the list!
scope=3D"row">
color=3D"#660000" size=3D"3" face=3D"Georgia, Times New Roman, Times, =
serif">*
scope=3D"row">
Arial,
Helvetica, sans-serif"> The "Official" Budget Manager, as
pulled from FSU's OMNI System, will be informed via email of this order.
color=3D"#660000" size=3D"3" face=3D"Georgia, Times New Roman, Times, =
serif">
*
size=3D"1"
face=3D"Verdana, Arial, Helvetica, sans-serif">One-Time =
(non-recurring)
charges will appear on the charge detail of the phone line for the above
mentioned Budget Manager.
size=3D"1" face=3D"Verdana, Arial, Helvetica, sans-serif">Chartfields =
can
ONLY be applied to monthly (recurring), NOT 1-time (non-recurring)
or construction charges.
cellpadding=3D"5">
Arial,
Helvetica, sans-serif">1
Helvetica, sans-serif">If Fund Code begins with "5" (Sponsored
Research), a 6-digit Project must be entered (type over zeros).
Arial,
Helvetica, sans-serif">Complete this side ONLY i
color=3D"#000000">f
face=3D"Verdana, Arial, Helvetica, sans-serif">Budget (OMNI) information
differs from left side OR if order is for construction*
Arial, Helvetica, sans-serif">
type=3D"checkbox"
id=3D"BasicSvc_Features" tabindex=3D"24" value=3D"Basic Service =
Features"
onClick=3D"alert('If you will be requiring installation or relocation of
phone jack/outlet, please check box under WIRING REQUIRED below')">
size=3D"1"
face=3D"Verdana, Arial, Helvetica, sans-serif">
order
must contain the following information: Phone number on which to place
voice mail; Attendant phone number; Class of Service; Size/Type of Box;
and User name.')" type=3Dcheckbox value=3D"Voice Mail" tabindex=3D"30"
name=3D"Voice_Mail">
size=3D"1" face=3D"Verdana, Arial, Helvetica, sans-serif">
href=3D"http://www.otc.fsu.edu/Department/Offer/VMOffer.html "
target=3D"_blank">Voice Mail
Helvetica, sans-serif">
href=3D"http://www.otc.fsu.edu/Department/Offer/MMCOffer.htm l"
target=3D"_blank">Meet-Me Conference (Up to 30
participants)
Helvetica, sans-serif">
Cellular Purchase. By submitting an online order for a Cellular Purchase
you recognize that each department and respective department heads are
responsible for all cellular phone charges incurred. Cellular phones are
to be used only for University and State business.')" tabindex=3D"33"
type=3Dcheckbox value=3D"Cellular Service" name=3D"Cellular_Service">
face=3D"Verdana,
Arial, Helvetica, sans-serif">
you
will be requiring installation or relocation of cable jack/outlet,
please check box under WIRING REQUIRED below')" value=3D"Seminole
Cablevision (SCV)" name=3D"SCV" tabindex=3D"34">
face=3D"Verdana,
Arial, Helvetica, sans-serif">
href=3D"http://www.otc.fsu.edu/Department/Offer/SCVOffer.htm l">Cable TV
Service (Seminole CableVision)
face=3D"Verdana,
Arial, Helvetica, sans-serif">
type=3D"checkbox" id=3D"Networking" onClick=3D"alert('If you will be =
requiring
installation or relocation of network jack/outlet, please check box
under WIRING REQUIRED below')" value=3D"Networking Services">
face=3D"Verdana,
Arial, Helvetica, sans-serif">High Speed Internet Access
(off-campus)
Helvetica, sans-serif">
id=3D"DSL"
tabindex=3D"37" onClick=3D"alert('If you will be requiring installation =
or
relocation of DSL jack/outlet, please check box under WIRING REQUIRED
below')" value=3D"Digital Subscriber Lines (Dept)">
Helvetica, sans-serif">
href=3D"http://www.otc.fsu.edu/Department/Offer/InternetOffe r.html#dsl">F=
S
U@Home (DSL)
Helvetica, sans-serif">
tabindex=3D"38"
onClick=3D"alert('If you will be requiring installation or relocation of
Cable Internet jack/outlet, please check box under WIRING REQUIRED
below')" type=3D"checkbox" id=3D"Cable_Internet" value=3D"Cable =
Internet">
Helvetica, sans-serif">
href=3D"http://www.otc.fsu.edu/Department/Offer/InternetOffe r.html#cable"=
>
Cable Internet
Helvetica,
sans-serif">
id=3D"Wiring"
tabindex=3D"42" value=3D"Phone PC CATV Wiring">
Helvetica, sans-serif">Check if ANY part of this order requires
installation or relocation of phone, computer or cable jack/outlet,
alarm/card reader, etc.
Helvetica, sans-serif"> Check if an estimate is required BEFORE
processing order
cellspacing=3D"0"
cellpadding=3D"3">
size=3D"1"
face=3D"Verdana, Arial, Helvetica, sans-serif">TO VOID AN ENTIRE
ORDER
Helvetica, sans-serif">
Help
Files" width=3D18 height=3D18>
Helvetica, sans-serif"> Email
target=3D"_blank">orders@otc.fsu.edu & provide TSR Order
Number
id=3D"t_Customer_Description">
Helvetica, sans-serif">DETAILS OF WORK
src=3D"images/stargreens.gif" alt=3D"Required Field!">
(Please try to be as specific as
possible)
size=3D"1" face=3D"Verdana, Arial, Helvetica, sans-serif"> ** If =
color=3D"#990000">special due date needed other than the
10-business-day standard turnaround, explain here **
size=3D"2">
rows=3D10
tabindex=3D"44">
cellpadding=3D"6"
cellspacing=3D"0">
Helvetica, sans-serif">Click the Send button
only ONCE!
It may take several moments to process
information.
id=3D"new_record" tabindex=3D"45" value=3D"Send Form to OTC">
Helvetica, sans-serif">
Help
Files" border=3D"0">
href=3D"http://www.otc.fsu.edu/Department/OrderInfo.html"
target=3D"_blank">What happens after I place my Order?
sans-serif">For questions, comments or technical difficulties on this
form, email
href=3D"mailto:help@otc.fsu.edu">help@otc.fsu.edu
// configure a connection to FileMaker Server Advanced
$ordersQuery =3D new FX('www2.otc.fsu.edu', '80', 'FMPro7');
// set database and layout information
$ordersQuery->SetDBData('WEB_Forms.fp7', 'Orders_FormView');
// set database username and password
$ordersQuery->SetDBUserPass('***', '***');
// retrieve all records in this database available to the current user
// add parameter array for new record
$ordersQuery->AddDBParamArray($newRecordArray);
// Add pararameters for the checkboxes. This allows some to be not
checked without an error.
$checkBoxes =3D
array('BasicSvc_Features','Instrument','Number_800','Calling _Card','COS'
,'Auth_Code','Voice
Mail','VM_Passcode_Reset','Meet_Me','Cellular_Service','SCV' ,'Video_Conf
erence','Networking','DSL','Cable_Internet','Access_System', 'Budget_Info
_Change','Information_Change','Wiring', 'Estimate');
foreach($checkBoxes as $checkBox) {
if(isset($_POST[$checkBox])) {
$ordersQuery->AddDBParam($checkBox, $_POST[$checkBox]);
}
}
// Add pararameters for the drop-down lists. This allows some to be
empty without an error.
$dropBoxes =3D
array('Contact_Bldg','Department_Name','Service_Location_Bld g','ChartFie
ld_1','ChartField_2','ChartField_3');
foreach($dropBoxes as $dropBox) {
if(isset($_POST[$dropBox])) {
$ordersQuery->AddDBParam($dropBox, $_POST[$dropBox]);
}
}
$orders =3D $ordersQuery->DoFXAction(FX_ACTION_NEW);
foreach ($orders as $order);
?>
//define the receiver of the email
$to =3D ($order['BudgetMgrEmail_OMNI_REC'].', =
'.$_POST['Contact_Email'].',
'.$_POST['Budget_Email_Address'].', CustomerCare@otc.fsu.edu');
//define the subject of the email
$subject =3D 'Online TSR Order Number '.$order['Order_Number'];=20
//create a boundary string. It must be unique=20
//so we use the MD5 algorithm to generate a random hash
$random_hash =3D md5(date('r', time()));=20
//define the headers we want passed. Note that they are separated with
\r\n
$headers =3D "From: Orders@otc.fsu.edu\r\nReply-To:
Customer_Care@otc.fsu.edu\r\nbcc: otconlineorders@otc.fsu.edu";
//add boundary string and mime type specification
$headers .=3D "\r\nContent-Type: multipart/alternative;
boundary=3D\"PHP-alt-".$random_hash."\"";=20
//define the body of the message.
ob_start(); //Turn on output buffering
IMPORTANT: Do not reply to this email, it is not monitored. Direct
inquires to Customer_Care@otc.fsu.edu
This is an auto-generated confirmation to the email addresses submitted
as either the budget authority and/or contact for the following Office
of Telecommunications Online Order. =20
IF APPROVED, NO ACTION IS REQUIRED!! If not approved, send an email to
Customer_Care@otc.fsu.edu to deny this request within 3 business days.
**** Construction projects cannot be used for recurring
charges.
Completion of this request will be coordinated through you by your
consultant (10 business day average turnaround; some exceptions apply.)
Additional information should be sent to Customer_Care@otc.fsu.edu.
--------------------
Need Assistance?
Online:
- Getting Started: http://www.otc.fsu.edu/GS.html
- Department Menu: http://www.otc.fsu.edu/Department/DeptMenu.html
(Look for the link to Instructions)
- OTC Home: http://www.otc.fsu.edu/
In Person: 105 Rod K. Shaw Building (On the corner of Call and Dewey) By
Phone: 644-HELP
Email: Customer_Care@otc.fsu.edu
Thank you again for the opportunity to be of service.
face=3D"Verdana, Arial, Helvetica, sans-serif">IMPORTANT: Do not
reply to this email, it is not monitored. Direct inquires to
href=3D"maito:Customer_Care@otc.fsu.edu">Customer_Care@otc.f su.edu
O
NT>.
sans-serif">This
is an auto-generated confirmation to the email addresses submitted as
either the budget authority and/or contact for the following Office of
Telecommunications Online Order.
sans-serif">IF
APPROVED, NO ACTION IS REQUIRED!! If not approved, send an email to
href=3D"maito:Customer_Care@otc.fsu.edu">Customer_Care@otc.f su.edu =
to
deny this request within 3 business days.
=20
sans-serif">*NOTE: Construction projects cannot be used for
recurring (monthly) charges!
Arial,
Helvetica, sans-serif">Completion of this request will be coordinated
through you by your consultant (10 business day average turnaround; some
exceptions apply.) Additional information should be sent to
href=3D"maito:Customer_Care@otc.fsu.edu">Customer_Care@otc.f su.edu.
F
ONT>
face=3D"Verdana,
Arial, Helvetica, sans-serif">The following information was pulled
from FSU's OMNI System. The Budget Manager listed below will be informed
via email of this order. If this information is incorrect, please report
it to your Budget Manager immediately.
face=3D"Verdana,
Arial, Helvetica, sans-serif">Budget Manager in OMNI--
sans-serif">
Department Menu:
href=3D"http://www.otc.fsu.edu/Department/DeptMenu.html"
target=3D"_blank">http://www.otc.fsu.edu/Department/DeptMenu .html
(Look for the link to Instructions)
sans-serif">In
Person:
sans-serif">105 Rod K. Shaw Building (On the corner of Call and Dewey)
sans-serif">By
Phone: 644-HELP
Email:
href=3D"maito:Customer_Care@otc.fsu.edu">Customer_Care@otc.f su.edu
O
NT>
sans-serif">Thank
you again for the opportunity to be of service.
OTC Online Order Confirmation
bgColor=3D#ffffff>
//copy current buffer contents into $message variable and delete current
output buffer
$message =3D ob_get_clean();
//send the email
$mail_sent =3D @mail( $to, $subject, $message, $headers );
//if the message is sent successfully print "Mail sent". Otherwise print
"Mail failed"=20
echo $mail_sent ? "
Please =
print
for your records. An email has been sent to OTC, the contact
email, the budget manager email and the email of the OMNI-specified
Budget Manager. " : "
size=3D'2'>Please print for your records and call 644-HELP.
Confirmation e-mail FAILED!
face=3D"Verdana,
Arial, Helvetica, sans-serif">Completion of this request will be
coordinated through you by your consultant (10 business day average
turnaround; some exceptions apply.) Additional information should be
sent to
href=3D"maito:Customer_Care@otc.fsu.edu">Customer_Care@otc.f su.edu.
F
ONT>
face=3D"Verdana, Arial, Helvetica, sans-serif">The following
information was pulled from FSU's OMNI System. The Budget Manager listed
below will be informed via email of this order. If this information is
incorrect, please report it to your Budget Manager
immediately.
face=3D"Verdana, Arial, Helvetica, sans-serif">Budget Manager in
OMNI--
sans-serif"> Department Menu:
href=3D"http://www.otc.fsu.edu/Department/DeptMenu.html"
target=3D"_blank">http://www.otc.fsu.edu/Department/DeptMenu .html
(Look for the link to Instructions)
sans-serif">Thank you again for the opportunity to be of
service.
-----Original Message-----
From: OKi98 [mailto:oki98@centrum.cz]=20
Sent: Monday, October 15, 2007 2:06 PM
To: VanBuskirk, Patricia
Cc: Instruct ICC; php-db@lists.php.net
Subject: Re: [PHP-DB] php maximum characters in text field
VanBuskirk, Patricia napsal(a):
> It isn't sending to MySql, we use FileMaker Pro 9. A new record did
not get made in the d'base... the confirmation email went out, but
wherever info was supposed to kick back from the d'base (ie. Order
number), it showed an "undefined variable" error.
>
> -----Original Message-----
> From: Instruct ICC [mailto:instructicc@hotmail.com]=20
> Sent: Monday, October 15, 2007 1:05 PM
> To: php-db@lists.php.net
> Subject: RE: [PHP-DB] php maximum characters in text field
>
>
> =20
>> I am starting to believe it is NOT the character length that is
causing the problem. We have received other orders with more in it than
that, and they came in ok. I think there may be something in the input
that php does not like. I've been searching for code that will "clean
up" input, possibly preg_replace?
>> =20
>
> Was the order received, but the text was shorter than expected?
> Or was the order not "received" at all?
>
> Check your mysql query log. It may show failed queries where bad
characters made the query fail, perhaps using ' or "?
> Use mysql_real_escape_string.
> ____________________________________________________________ _____
> Climb to the top of the charts! Play Star Shuffle: the word scramble
challenge with star power.
>
http://club.live.com/star_shuffle.aspx?icid=3Dstarshuffle_wl mailtextlink_=
o
ct
> =20
post the code (form + script that proccesses passed variables +=20
print_r($_POST) ), it'll make the things much quicker.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: php maximum characters in text field
am 15.10.2007 21:09:52 von pvanbuskirk
Here is the exact text he submitted:
Please initiate phone lines in the following locations in the Leon
County Civic Center to support our home Men's and Women's Basketball
games. Meeting room B: activate 4 lines on the North Wall and 4 lines on
the South Wall - all lines should have long distance with credit card
only. Courtside: 1 - Please re-activate saved phone number 224-8790
along the West side press row. Please include long distance on the
phone. 2 - Please activate the ISDN line on the East side scorer's
table. 3 - Please re-activate the saved phone number 224-1155 on the
East side scorer's table. Work room: Please activate 2 lines in the work
room, one for telephone and one for fax. - Both with long distance
capability Please call, e-mail or fax the telephone numbers associated
with each location to Stuart Pearce at 644-4694 (office), 645-3278
(fax), spearce@mailer.fsu.edu. Thank you, Stuart Pearce
-----Original Message-----
From: Bastien Koert [mailto:bastien_k@hotmail.com]=20
Sent: Monday, October 15, 2007 1:48 PM
To: VanBuskirk, Patricia; Instruct ICC; php-db@lists.php.net
Subject: RE: [PHP-DB] php maximum characters in text field
Could it be an '&' ampersand in the data?
=20
Bastien> Date: Mon, 15 Oct 2007 13:29:02 -0400> From:
pvanbuskirk@otc.fsu.edu> To: instructicc@hotmail.com;
php-db@lists.php.net> Subject: RE: [PHP-DB] php maximum characters in
text field> > It isn't sending to MySql, we use FileMaker Pro 9. A new
record did not get made in the d'base... the confirmation email went
out, but wherever info was supposed to kick back from the d'base (ie.
Order number), it showed an "undefined variable" error.> > -----Original
Message-----> From: Instruct ICC [mailto:instructicc@hotmail.com] >
Sent: Monday, October 15, 2007 1:05 PM> To: php-db@lists.php.net>
Subject: RE: [PHP-DB] php maximum characters in text field> > > > I am
starting to believe it is NOT the character length that is causing the
problem. We have received other orders with more in it than that, and
they came in ok. I think there may be something in the input that php
does not like. I've been searching for code that will "clean up" input,
possibly preg_replace?> > Was the order !
received, but the text was shorter than expected?> Or was the order not
"received" at all?> > Check your mysql query log. It may show failed
queries where bad characters made the query fail, perhaps using ' or "?>
Use mysql_real_escape_string.>
____________________________________________________________ _____> Climb
to the top of the charts! Play Star Shuffle: the word scramble
challenge with star power.>
http://club.live.com/star_shuffle.aspx?icid=3Dstarshuffle_wl mailtextlink_=
o
ct> -- > PHP Database Mailing List (http://www.php.net/)> To
unsubscribe, visit: http://www.php.net/unsub.php> > -- > PHP Database
Mailing List (http://www.php.net/)> To unsubscribe, visit:
http://www.php.net/unsub.php>=20
____________________________________________________________ _____
Express yourself with free Messenger emoticons. Get them today!
http://www.freemessengeremoticons.ca/?icid=3DEMENCA122
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
> Date: Mon, 15 Oct 2007 15:09:52 -0400
> From: pvanbuskirk@otc.fsu.edu
> To: bastien_k@hotmail.com; instructicc@hotmail.com; php-db@lists.php.net
> Subject: RE: [PHP-DB] php maximum characters in text field
>=20
> Here is the exact text he submitted:
>=20
> Please initiate phone lines in the following locations in the Leon
> County Civic Center to support our home Men's and Women's Basketball
> games. Meeting room B: activate 4 lines on the North Wall and 4 lines on
> the South Wall - all lines should have long distance with credit card
> only. Courtside: 1 - Please re-activate saved phone number 224-8790
> along the West side press row. Please include long distance on the
> phone. 2 - Please activate the ISDN line on the East side scorer's
> table. 3 - Please re-activate the saved phone number 224-1155 on the
> East side scorer's table. Work room: Please activate 2 lines in the work
> room, one for telephone and one for fax. - Both with long distance
> capability Please call, e-mail or fax the telephone numbers associated
> with each location to Stuart Pearce at 644-4694 (office), 645-3278
> (fax), spearce@mailer.fsu.edu. Thank you, Stuart Pearce
____________________________________________________________ _____
Help yourself to FREE treats served up daily at the Messenger Caf=E9. Stop =
by today.
http://www.cafemessenger.com/info/info_sweetstuff2.html?ocid =3DTXT_TAGLM_Oc=
tWLtagline=
--_aed0528b-a056-416f-9d1c-8f7b43655dc5_--
RE: php maximum characters in text field
am 17.10.2007 18:40:04 von pvanbuskirk
Does anyone know how to look for a "Curly quote" or "typographer's =
quotation mark". They are being submitted on our form under customer =
description. I have created a function that replaces a regular straight =
quotation mark ($title =3D str_replace("'", "", $title);), but do not =
know what to put in as the "look for" for the curly mark!
-----Original Message-----
From: Instruct ICC [mailto:instructicc@hotmail.com]=20
Sent: Monday, October 15, 2007 3:29 PM
To: php-db@lists.php.net
Subject: RE: [PHP-DB] php maximum characters in text field
Do you see those apostrophes in that text?
They need to be properly escaped.
> Date: Mon, 15 Oct 2007 15:09:52 -0400
> From: pvanbuskirk@otc.fsu.edu
> To: bastien_k@hotmail.com; instructicc@hotmail.com; =
php-db@lists.php.net
> Subject: RE: [PHP-DB] php maximum characters in text field
>=20
> Here is the exact text he submitted:
>=20
> Please initiate phone lines in the following locations in the Leon
> County Civic Center to support our home Men's and Women's Basketball
> games. Meeting room B: activate 4 lines on the North Wall and 4 lines =
on
> the South Wall - all lines should have long distance with credit card
> only. Courtside: 1 - Please re-activate saved phone number 224-8790
> along the West side press row. Please include long distance on the
> phone. 2 - Please activate the ISDN line on the East side scorer's
> table. 3 - Please re-activate the saved phone number 224-1155 on the
> East side scorer's table. Work room: Please activate 2 lines in the =
work
> room, one for telephone and one for fax. - Both with long distance
> capability Please call, e-mail or fax the telephone numbers associated
> with each location to Stuart Pearce at 644-4694 (office), 645-3278
> (fax), spearce@mailer.fsu.edu. Thank you, Stuart Pearce
____________________________________________________________ _____
Help yourself to FREE treats served up daily at the Messenger Caf=E9. =
Stop by today.
http://www.cafemessenger.com/info/info_sweetstuff2.html?ocid =3DTXT_TAGLM_=
OctWLtagline
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: php maximum characters in text field
am 17.10.2007 19:53:49 von Instruct ICC
> Does anyone know how to look for a "Curly quote" or "typographer's quotat=
ion mark". They are being submitted on our form under customer description.=
I have created a function that replaces a regular straight quotation mark =
($title =3D str_replace("'", "", $title);), but do not know what to put in =
as the "look for" for the curly mark!
How do you know they are submitting ?
Can you copy from that source, then paste it into your str_replace functio=
n?
Or since it seems to be a two-byte character (I didn't see it at asciitable=
..com):
Maybe you need http://php.he.net/manual/en/ref.mbstring.php
mb_ereg_replace
____________________________________________________________ _____
Peek-a-boo FREE Tricks & Treats for You!
http://www.reallivemoms.com?ocid=3DTXT_TAGHM&loc=3Dus=
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: php maximum characters in text field
am 17.10.2007 20:10:22 von pvanbuskirk
I was able to copy and paste from the customer's email exactly what they
were trying to submit. When I back-spaced out their single quote and
put in my own, it worked fine. That's how I narrowed it down to that
particular character. With much help from a coworker, I was able to
implement some functions, and call them BEFORE php tries to create the
new record in the database. That was my biggest problem ... I put the
cleanup code in the wrong place, after the new record command. However,
here's what the function looks like (it also gets out ~'s:
-----Original Message-----
From: Instruct ICC [mailto:instructicc@hotmail.com]=20
Sent: Wednesday, October 17, 2007 1:54 PM
To: php-db@lists.php.net
Subject: RE: [PHP-DB] php maximum characters in text field
> Does anyone know how to look for a "Curly quote" or "typographer's
quotation mark". They are being submitted on our form under customer
description. I have created a function that replaces a regular straight
quotation mark ($title =3D str_replace("'", "", $title);), but do not =
know
what to put in as the "look for" for the curly mark!
How do you know they are submitting ?
Can you copy from that source, then paste it into your str_replace
function?
Or since it seems to be a two-byte character (I didn't see it at
asciitable.com):
Maybe you need http://php.he.net/manual/en/ref.mbstring.php
mb_ereg_replace
____________________________________________________________ _____
Peek-a-boo FREE Tricks & Treats for You!
http://www.reallivemoms.com?ocid=3DTXT_TAGHM&loc=3Dus
--=20
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: php maximum characters in text field
am 17.10.2007 23:39:22 von Niel Archer
Hi
> Does anyone know how to look for a "Curly quote" or "typographer's quotation mark".
Do you mean the equivalent of the left and right double quote entities
in HTML (or 66's and 99's as we called them at school)?
--
Niel Archer
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: php maximum characters in text field
am 18.10.2007 13:29:14 von pvanbuskirk
I have always called them curly quotes and when I Googled "curly quotes
in php", I came up with the script I sent yesterday. But, I think you
are right.
-----Original Message-----
From: Niel Archer [mailto:not@chance.now]=20
Sent: Wednesday, October 17, 2007 5:39 PM
To: php-db@lists.php.net
Subject: Re: [PHP-DB] php maximum characters in text field
Hi
> Does anyone know how to look for a "Curly quote" or "typographer's
quotation mark".
Do you mean the equivalent of the left and right double quote entities
in HTML (or 66's and 99's as we called them at school)?
--
Niel Archer
--=20
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
email HTML code showing in Eudora
am 18.10.2007 17:15:45 von pvanbuskirk
I have the following code that so for works perfect for all email
programs EXCEPT Eudora. With Eudora, the entire code after the first
?>, starting at "--PHP-alt" just pops into the body of the email.
Anyone know of a fix for Eudora that will still allow the rest of the
world to see it correctly?
//define the receiver of the email
$to =3D 'youraddress@example.com';
//define the subject of the email
$subject =3D 'Test HTML email';=20
//create a boundary string. It must be unique=20
//so we use the MD5 algorithm to generate a random hash
$random_hash =3D md5(date('r', time()));=20
//define the headers we want passed. Note that they are separated with
\r\n
$headers =3D "From: webmaster@example.com\r\nReply-To:
webmaster@example.com";
//add boundary string and mime type specification
$headers .=3D "\r\nContent-Type: multipart/alternative;
boundary=3D\"PHP-alt-".$random_hash."\"";=20
//define the body of the message.
ob_start(); //Turn on output buffering
?>
--PHP-alt- =20
Content-Type: text/plain; charset=3D"iso-8859-1"=20
Content-Transfer-Encoding: 7bit
Hello World!!!=20
This is simple text email message.=20
![](3D"images/note-btn.gif"<br)
alt=3D"Note icon" width=3D"15" height=3D"15">![3D"Required](3D"images/stargreens.gif")
![3D"note](3D"images/note-btn.gif")
height=3D"15" />![3D"clear](3D"/images/spacer.gif")
width=3D"15" height=3D"1" />![3D"Access](3D"images/tipblue.gif")
Help![3D"Access](3D"images/starred.gif")
Help![3D"spacer"](3D"images/clearpixel.gif"){kind=tracking}
width=3D"200"![](3D"images/tsr_confbanner.jpg")
alt=3D"confirmation